If the sp_msforeachtable is not available, you can also run the delete query multiple times, since the tables which depend on others are then deleted :) – ... ... <看更多>

DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR. SET @Cursor = CURSOR FAST_FORWARD FOR. SELECT DISTINCT sql = 'ALTER TABLE [' + tc2. ... <看更多>

By being very cautious and aware that this will erase all tables and their configurations, triggers, attached views, you can execute the ... ... <看更多>